Replace Substr in MYSQL VALUE

select * from wp_posts where ID=2;

UPDATE wp_posts
SET guid = REPLACE(guid, ‘http://ta.leeroy.ca/’, ‘http://talt.leeroy.ca/’)
where guid like “http://ta.leeroy.ca/%” and ID=123